# -*- coding:utf-8 -*-

from sqlalchemy import Column, ForeignKey, DateTime, Integer, String
from config.database import BaseMixin, Base

class BgVip(Base, BaseMixin):
    """
    素材vip表
    """
    __tablename__ = "bg_vip"

    begin_date = Column(DateTime, nullable=False, comment='开始时间')
    end_date = Column(DateTime, nullable=False, comment='结束时间')
    status = Column(String(1), nullable=False, comment='状态')
    user_id = Column(Integer, nullable=False, comment='用户id')
    count = Column(Integer, nullable=False, comment='下单次数')
    vip_level = Column(String(10), default='1', comment='VIP等级')
    total_amount = Column(Integer, default=0, comment='累计消费金额')


